use KBCQuiz
go
select * from Question
go

insert into Question values ('1+1 = ?','12','13','14','2','2')
insert into Question values ('Question: In the United States the television broadcast standard is...?','PAL','NSTC','SECAM','RGB','RGB') 
insert into Question values ('Question: In the UK, what type of installation requires a firemans switch?','Neon Lighting ','High Pressure Sodium Lighting ','Water','Water Features ','Water') 
insert into Question values ('Question: Which countrys Antarctic claim covers the greatest swath of longitude?','Neon Lighting ','New Zealand','Australia','Argentina','New Zealand')
insert into Question values ('Question: Which Pacific entity is farthest north?','Federated States of Micronesia','Palau','Northern Mariana Islands','Guam','Palau')
insert into Question values ('Question: Which country follows the United States and China in total number of Internet users?','Germany','France','Japan','Chinal','France')
insert into Question values ('Question: Which country has the lowest rate of newspaper circulation per capita?','Indonesia','Iceland','Japan','Italy','Italy')
insert into Question values ('Question: Iraq borders with how many countries?','4','12','5','16','5')
insert into Question values ('In 1917-18 Iraq became independent from which Empire?','Sumerians','Ottoman','Babylonian','Assyrians','Ottoman')
insert into Question values ('Question: In which year did the Republic of Iraq become independent?','1922','1993','1994','1996','1996')
insert into Question values ('Question: Pick out the one country whose currency is not "the pound"...?','Falkland Islands','StHelena','Somalia','Syria','Syria')
insert into Question values ('Question: Choose the country which doesnt use the franc...?','CongoIslands','Tonga','Somalia','Togo','Togo')
insert into Question values ('Question: One of these countries does not have the rupee as its currency. Which one?','Lanka','Seychelles','India','Bangladesh','India')
insert into Question values ('Question: Which of these rivers doesnt rise in India?','Kaveri','Brahmaputra','Ganga','Kanyakumar','Kanyakumar')
insert into Question values ('Question: How many lions are there in our national emblem???','One','Two','Four','Eight','Eight')
insert into Question values ('Question: Which was the first vessel acquired by the Department of Ocean Development (DOD ?','Sagar','Vikas','Sampada','Lakhsmi','Vikas')
insert into Question values ('Question: One of the richest states of India,the five rivers that once flowed ??','Everest','Cardamom','Karakoram','Kanchenjung','Cardamom')
insert into Question values ('Question: Which Indian city, famous for its lagoons, is known as the Venice of the East?','Hyderabad','Jaipur','Mumbai','Alleppey','Alleppey')
insert into Question values ('.... Tom absent from the class again?','Are','Is','Am','All correct','Is')
insert into Question values ('He ..... cofee for breakfast every morning','have','has','had','haves','has')
insert into Question values ('What can you see at a zoo?','movies','doctors','animals','nurses','animals')
insert into Question values ('Which country has the most people?','India','China','Japan','Korea','China')
insert into Question values ('Which is the tallest animal?','a horse','an elephant','a giraffe','a monkey','a giraffe')
insert into Question values ('Ham is meat from ?','a cow','a pig','a hamster','a monkey','a pig')
insert into Question values ('West is the opposite direction to ?','east','north','south','no correct answer','east')
insert into Question values ('Concentrated; focused; determined; resolute; purposeful ?','intent','bulk','party','fortunate','intent')
insert into Question values ('Having the back side exposed to view; opposite; contrary ?','periodical','brokered','reverse','superior','reverse')
insert into Question values ('To arrange according to dimension ?','pressure','judge','size','leave','size')
insert into Question values ('Transgressor; person who breaks the law; one who insults ?','shortage','offender','capex','market','offender')
insert into Question values ('Can be prophesied; can be foretold ?','visible','urgent','fluent','predictable','predictable')
insert into Question values ('Offer; plan; theory; problem ?','midmorning','apology','proposition','dietician','proposition')
insert into Question values ('Up to ?','beyond','opposite','until','behind','until')
insert into Question values ('To deliver a discourse before an audience; to reprimand tediously ?','interest','lecture','piece','dial','lecture')
insert into Question values ('Quiet; tranquil; calm; motionless ?','still','lucid','second','tense','still')
insert into Question values ('Kind; good ?','beneficent','local','unjudged','superfluous','beneficent')
insert into Question values ('To present in a condensed form; to list the main points in a brief and comprehensive manner ?','summarize','stall','pocket','loop','summarize')
insert into Question values ('To alter; to change; to fluctuate ?','aim','adorn','idle','vary','vary')
insert into Question values ('Since; inasmuch as; while; while on the contrary ?','whereas','unless','though','directly','whereas')
insert into Question values ('Newspaper; magazine; diary; blog; bookkeeping ledger ?','journal','supply','claim','significance','journal')
insert into Question values ('Something which is opposite ?','language','contrary','timeliness','selection','contrary')
go
insert into Admin values('admin','admin','Pham Kim Long','08-08-1992','phamkimlong0808@gmail.com')
go
select * from Admin
go
insert into Player values ('Long','phamkimlong0808@gmail.com','08/08/1992','Nghe An',1000)
insert into Player values ('Chung','chung@yahoo.com','1/16/1993','Nghe An',2000)
insert into Player values ('Tuan Anh','tuananh@yahoo.com','3/8/1989','Hai Duong',700) 
go
select * from Player
go
select * from Question

